<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" data-whc_version="25.0">
    <head><link rel="shortcut icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><link rel="icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/><meta name="viewport" content="width=device-width, initial-scale=1.0"/><meta http-equiv="X-UA-Compatible" content="IE=edge"/><meta name="copyright" content="(C) Copyright 2024"/><meta name="generator" content="DITA-OT"/><meta name="description" content="The Google BigQuery executor runs one or more SQLÂ queriesÂ on Google BigQuery each time it receives an event record. For information about supported versions, see Supported Systems and Versions . Use ..."/><meta name="prodname" content="Data Collector"/><meta name="version" content="3"/><meta name="release" content="16"/><meta name="modification" content="0"/>        
      <title>Google BigQuery</title><!--  Generated with Oxygen version 25.1, build number 2023042410.  --><meta name="wh-path2root" content="../../../"/><meta name="wh-toc-id" content="concept_sqc_w4w_ktb-d16893e57554"/><meta name="wh-source-relpath" content="datacollector/UserGuide/Executors/GBQuery-E.dita"/><meta name="wh-out-relpath" content="datacollector/UserGuide/Executors/GBQuery-E.html"/>

    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/commons.css?buildId=2023042410"/>
    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/topic.css?buildId=2023042410"/>

    <script src="../../../oxygen-webhelp/app/options/properties.js?buildId=20240802104629"></script>
    <script src="../../../oxygen-webhelp/app/localization/strings.js?buildId=2023042410"></script>
    <script src="../../../oxygen-webhelp/app/search/index/keywords.js?buildId=20240802104629"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/commons.js?buildId=2023042410"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/topic.js?buildId=2023042410"></script>
<link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/template/light.css?buildId=2023042410"/><link rel="stylesheet" type="text/css" href="../../../skin.css"/></head>

    <body class="wh_topic_page frmBody">
        
        
        

        
<nav class="navbar navbar-default wh_header" data-whc_version="25.0">
    <div class="container-fluid">
        <div class="wh_header_flex_container navbar-nav navbar-expand-md navbar-dark">
            <div class="wh_logo_and_publication_title_container">
                <div class="wh_logo_and_publication_title">
                    
                    <!--
                            This component will be generated when the next parameters are specified in the transformation scenario:
                            'webhelp.logo.image' and 'webhelp.logo.image.target.url'.
                            See: http://oxygenxml.com/doc/versions/17.1/ug-editor/#topics/dita_webhelp_output.html.
                    -->
                    
                    <div class=" wh_publication_title "><a href="../../../index.html"><span class="booktitle">  <span class="ph mainbooktitle"><span class="ph">Data Collector</span> User Guide</span>  </span></a></div>
                    
                </div>
                
                <!-- The menu button for mobile devices is copied in the output only when the 'webhelp.show.top.menu' parameter is set to 'yes' -->
                
            </div>

            <div class="wh_top_menu_and_indexterms_link collapse navbar-collapse">
                
                
                <div class=" wh_indexterms_link "><a href="../../../indexTerms.html" title="Index" aria-label="Go to index terms page"><span>Index</span></a></div>
                
            </div>
        </div>
    </div>
</nav>

        <div class=" wh_search_input navbar-form wh_topic_page_search search " role="form">


<form id="searchForm" method="get" role="search" action="../../../search.html"><div><input type="search" placeholder="Search " class="wh_search_textfield" id="textToSearch" name="searchQuery" aria-label="Search query" required="required"/><button type="submit" class="wh_search_button" aria-label="Search"><span class="search_input_text">Search</span></button></div></form>

</div>
        
        <div class="container-fluid">
            <div class="row">

                <nav class="wh_tools d-print-none">
                    
<div data-tooltip-position="bottom" class=" wh_breadcrumb "><ol class="d-print-none"><li><span class="home"><a href="../../../index.html"><span>Home</span></a></span></li><li><div class="topicref" data-id="concept_umc_1lk_fx"><div class="title"><a href="../../../datacollector/UserGuide/Executors/Executors-title.html">Executors</a></div></div></li><li class="active"><div class="topicref" data-id="concept_sqc_w4w_ktb"><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_sqc_w4w_ktb">Google BigQuery</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ol></div>



                    <div class="wh_right_tools "><button class="wh_hide_highlight" aria-label="Toggle search highlights" title="Toggle search highlights"></button><button class="webhelp_expand_collapse_sections" data-next-state="collapsed" aria-label="Collapse sections" title="Collapse sections"></button><div class=" wh_navigation_links "><span id="topic_navigation_links" class="navheader">
  
<span class="navprev"><a class="- topic/link link" href="../../../datacollector/UserGuide/Executors/GCS-E.html#concept_xym_npb_3qb" title="Google Cloud Storage" aria-label="Previous topic: Google Cloud Storage" rel="prev"></a></span>  
<span class="navnext"><a class="- topic/link link" href="../../../datacollector/UserGuide/Executors/HDFSMetadata.html#concept_wgj_slk_fx" title="HDFS File Metadata" aria-label="Next topic: HDFS File Metadata" rel="next"></a></span>  </span></div>
<!--External resource link-->
<div class=" wh_print_link print d-none d-md-inline-block "><button onClick="window.print()" title="Print this page" aria-label="Print this page"></button></div>
                        
                        
                        
                        
                    </div>
                </nav>
            </div>

            

<div class="wh_content_area">
                <div class="row">
                    


                        <nav role="navigation" id="wh_publication_toc" class="col-lg-3 col-md-3 col-sm-12 d-md-block d-none d-print-none">
<div id="wh_publication_toc_content">


                            <div class=" wh_publication_toc " data-tooltip-position="right"><span class="expand-button-action-labels"><span id="button-expand-action" role="button" aria-label="Expand"></span><span id="button-collapse-action" role="button" aria-label="Collapse"></span><span id="button-pending-action" role="button" aria-label="Pending"></span></span><ul role="tree" aria-label="Table of Contents"><li role="treeitem" aria-expanded="false"><div data-tocid="concept_htw_ghg_jq-d16893e53" class="topicref" data-id="concept_htw_ghg_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_htw_ghg_jq-d16893e53-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Getting_Started/GettingStarted_Title.html#concept_htw_ghg_jq" id="concept_htw_ghg_jq-d16893e53-link">Getting Started</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l2v_nlp_mpb-d16893e331" class="topicref" data-id="concept_l2v_nlp_mpb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l2v_nlp_mpb-d16893e331-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/ReleaseNotes/ReleaseNotes.html#concept_l2v_nlp_mpb" id="concept_l2v_nlp_mpb-d16893e331-link">Release Notes</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l4q_flb_kr-d16893e2582" class="topicref" data-id="concept_l4q_flb_kr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l4q_flb_kr-d16893e2582-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Installation/Install_title.html" id="concept_l4q_flb_kr-d16893e2582-link">Installation</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ylh_yyz_ky-d16893e3984" class="topicref" data-id="concept_ylh_yyz_ky" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ylh_yyz_ky-d16893e3984-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Configuration/Config_title.html" id="concept_ylh_yyz_ky-d16893e3984-link">Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ejk_f1f_5v-d16893e7058" class="topicref" data-id="concept_ejk_f1f_5v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ejk_f1f_5v-d16893e7058-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Upgrade/Upgrade_title.html" id="concept_ejk_f1f_5v-d16893e7058-link">Upgrade</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qsw_cjy_bt-d16893e10103" class="topicref" data-id="concept_qsw_cjy_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qsw_cjy_bt-d16893e10103-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Design/PipelineDesign_title.html" id="concept_qsw_cjy_bt-d16893e10103-link">Pipeline Concepts and Design</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qn1_wn4_kq-d16893e11199" class="topicref" data-id="concept_qn1_wn4_kq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qn1_wn4_kq-d16893e11199-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Configuration/PipelineConfiguration_title.html" id="concept_qn1_wn4_kq-d16893e11199-link">Pipeline Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hdr_gyw_41b-d16893e13057" class="topicref" data-id="concept_hdr_gyw_41b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hdr_gyw_41b-d16893e13057-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Formats/DataFormats-Title.html" id="concept_hdr_gyw_41b-d16893e13057-link">Data Formats</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yjl_nc5_jq-d16893e14164" class="topicref" data-id="concept_yjl_nc5_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yjl_nc5_jq-d16893e14164-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Origins_title.html" id="concept_yjl_nc5_jq-d16893e14164-link">Origins</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yjl_nc5_jq-d16893e35197" class="topicref" data-id="concept_yjl_nc5_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yjl_nc5_jq-d16893e35197-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Processors/Processors_title.html" id="concept_yjl_nc5_jq-d16893e35197-link">Processors</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_agj_cfj_br-d16893e44037" class="topicref" data-id="concept_agj_cfj_br" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_agj_cfj_br-d16893e44037-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Destinations-title.html" id="concept_agj_cfj_br-d16893e44037-link">Destinations</a></div></div></li><li role="treeitem" aria-expanded="true"><div data-tocid="concept_umc_1lk_fx-d16893e56072" class="topicref" data-id="concept_umc_1lk_fx" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_umc_1lk_fx-d16893e56072-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Executors-title.html" id="concept_umc_1lk_fx-d16893e56072-link">Executors</a></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem"><div data-tocid="concept_stt_2lk_fx-d16893e56094" class="topicref" data-id="concept_stt_2lk_fx" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Executors-overview.html#concept_stt_2lk_fx" id="concept_stt_2lk_fx-d16893e56094-link">Executors</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zhp_ldk_xhb-d16893e56118" class="topicref" data-id="concept_zhp_ldk_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zhp_ldk_xhb-d16893e56118-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/ADLS-G1-FileMeta.html#concept_zhp_ldk_xhb" id="concept_zhp_ldk_xhb-d16893e56118-link">ADLS Gen1 File Metadata (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_i22_k2k_xhb-d16893e56416" class="topicref" data-id="concept_i22_k2k_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_i22_k2k_xhb-d16893e56416-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/ADLS-G2-FileMeta.html#concept_i22_k2k_xhb" id="concept_i22_k2k_xhb-d16893e56416-link">ADLS Gen2 File Metadata</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_mvh_bnm_f1b-d16893e56714" class="topicref" data-id="concept_mvh_bnm_f1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_mvh_bnm_f1b-d16893e56714-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/AmazonS3.html#concept_mvh_bnm_f1b" id="concept_mvh_bnm_f1b-d16893e56714-link">Amazon S3</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fdc_qrx_jz-d16893e56919" class="topicref" data-id="concept_fdc_qrx_jz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fdc_qrx_jz-d16893e56919-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Databricks.html#concept_fdc_qrx_jz" id="concept_fdc_qrx_jz-d16893e56919-link">Databricks Job Launcher</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_bzl_3fq_zjb-d16893e57061" class="topicref" data-id="concept_bzl_3fq_zjb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_bzl_3fq_zjb-d16893e57061-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/DatabricksQuery.html#concept_bzl_3fq_zjb" id="concept_bzl_3fq_zjb-d16893e57061-link">Databricks Query </a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sjs_sfp_qz-d16893e57252" class="topicref" data-id="concept_sjs_sfp_qz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sjs_sfp_qz-d16893e57252-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Email.html#concept_sjs_sfp_qz" id="concept_sjs_sfp_qz-d16893e57252-link">Email</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xym_npb_3qb-d16893e57364" class="topicref" data-id="concept_xym_npb_3qb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xym_npb_3qb-d16893e57364-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GCS-E.html#concept_xym_npb_3qb" id="concept_xym_npb_3qb-d16893e57364-link">Google Cloud Storage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="true" class="active"><div data-tocid="concept_sqc_w4w_ktb-d16893e57554" class="topicref" data-id="concept_sqc_w4w_ktb" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_sqc_w4w_ktb-d16893e57554-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_sqc_w4w_ktb" id="concept_sqc_w4w_ktb-d16893e57554-link">Google BigQuery</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem"><div data-tocid="concept_elb_ftx_ktb-d16893e57578" class="topicref" data-id="concept_elb_ftx_ktb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_elb_ftx_ktb" id="concept_elb_ftx_ktb-d16893e57578-link">Prerequisite</a></div></div></li><li role="treeitem"><div data-tocid="concept_ixm_kyx_ktb-d16893e57600" class="topicref" data-id="concept_ixm_kyx_ktb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_ixm_kyx_ktb" id="concept_ixm_kyx_ktb-d16893e57600-link">Credentials</a></div></div></li><li role="treeitem"><div data-tocid="concept_lhs_nyy_ktb-d16893e57622" class="topicref" data-id="concept_lhs_nyy_ktb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_lhs_nyy_ktb" id="concept_lhs_nyy_ktb-d16893e57622-link">SQL Queries</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hsy_5vy_ktb-d16893e57646" class="topicref" data-id="concept_hsy_5vy_ktb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hsy_5vy_ktb-d16893e57646-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#concept_hsy_5vy_ktb" id="concept_hsy_5vy_ktb-d16893e57646-link">Event Generation</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="task_pqv_nrb_btb-d16893e57694" class="topicref" data-id="task_pqv_nrb_btb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/GBQuery-E.html#task_pqv_nrb_btb" id="task_pqv_nrb_btb-d16893e57694-link">Configuring a Google BigQuery Executor </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wgj_slk_fx-d16893e57718" class="topicref" data-id="concept_wgj_slk_fx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wgj_slk_fx-d16893e57718-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/HDFSMetadata.html#concept_wgj_slk_fx" id="concept_wgj_slk_fx-d16893e57718-link">HDFS File Metadata</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kjw_llk_fx-d16893e58029" class="topicref" data-id="concept_kjw_llk_fx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kjw_llk_fx-d16893e58029-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/HiveQuery.html#concept_kjw_llk_fx" id="concept_kjw_llk_fx-d16893e58029-link">Hive Query</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_j3r_gcv_sx-d16893e58207" class="topicref" data-id="concept_j3r_gcv_sx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_j3r_gcv_sx-d16893e58207-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/JDBCQuery.html#concept_j3r_gcv_sx" id="concept_j3r_gcv_sx-d16893e58207-link">JDBC Query</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ohx_r5h_z1b-d16893e58370" class="topicref" data-id="concept_ohx_r5h_z1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ohx_r5h_z1b-d16893e58370-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/MapRFSFileMeta.html#concept_ohx_r5h_z1b" id="concept_ohx_r5h_z1b-d16893e58370-link">MapR FS File Metadata</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_bj2_zlk_fx-d16893e58680" class="topicref" data-id="concept_bj2_zlk_fx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_bj2_zlk_fx-d16893e58680-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/MapReduce.html#concept_bj2_zlk_fx" id="concept_bj2_zlk_fx-d16893e58680-link">MapReduce</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qzm_l4r_kz-d16893e58905" class="topicref" data-id="concept_qzm_l4r_kz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qzm_l4r_kz-d16893e58905-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/PipelineFinisher.html#concept_qzm_l4r_kz" id="concept_qzm_l4r_kz-d16893e58905-link">Pipeline Finisher</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kcf_sn2_jlb-d16893e59039" class="topicref" data-id="concept_kcf_sn2_jlb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kcf_sn2_jlb-d16893e59039-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/SFTP.html#concept_kcf_sn2_jlb" id="concept_kcf_sn2_jlb-d16893e59039-link">SFTP/FTP/FTPS Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jsr_zpw_tz-d16893e59107" class="topicref" data-id="concept_jsr_zpw_tz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jsr_zpw_tz-d16893e59107-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Shell.html#concept_jsr_zpw_tz" id="concept_jsr_zpw_tz-d16893e59107-link">Shell</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xrx_crn_4qb-d16893e59241" class="topicref" data-id="concept_xrx_crn_4qb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xrx_crn_4qb-d16893e59241-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Snowflake-E.html#concept_xrx_crn_4qb" id="concept_xrx_crn_4qb-d16893e59241-link">Snowflake</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_cvy_vxb_1z-d16893e59451" class="topicref" data-id="concept_cvy_vxb_1z" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_cvy_vxb_1z-d16893e59451-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Spark.html#concept_cvy_vxb_1z" id="concept_cvy_vxb_1z-d16893e59451-link">Spark</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xxd_f5r_kx-d16893e59696" class="topicref" data-id="concept_xxd_f5r_kx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xxd_f5r_kx-d16893e59696-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Event_Handling/EventFramework-Title.html#concept_xxd_f5r_kx" id="concept_xxd_f5r_kx-d16893e59696-link">Dataflow Triggers</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zq5_pb4_flb-d16893e60134" class="topicref" data-id="concept_zq5_pb4_flb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zq5_pb4_flb-d16893e60134-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Solutions/Solutions-title.html" id="concept_zq5_pb4_flb-d16893e60134-link">Solutions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ugp_kwf_xw-d16893e61337" class="topicref" data-id="concept_ugp_kwf_xw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ugp_kwf_xw-d16893e61337-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/DPM/DPM_title.html" id="concept_ugp_kwf_xw-d16893e61337-link">StreamSets Control Hub</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fyf_gkq_4bb-d16893e62693" class="topicref" data-id="concept_fyf_gkq_4bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fyf_gkq_4bb-d16893e62693-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Edge_Mode/EdgePipelines_title.html" id="concept_fyf_gkq_4bb-d16893e62693-link"><span class="ph">StreamSets Data Collector Edge</span></a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wwq_gxc_py-d16893e63980" class="topicref" data-id="concept_wwq_gxc_py" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wwq_gxc_py-d16893e63980-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Multithreaded_Pipelines/MultithreadedPipelines.html#concept_wwq_gxc_py" id="concept_wwq_gxc_py-d16893e63980-link">Multithreaded Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gzw_tdm_p2b-d16893e64187" class="topicref" data-id="concept_gzw_tdm_p2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gzw_tdm_p2b-d16893e64187-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Microservice/Microservice_Title.html#concept_gzw_tdm_p2b" id="concept_gzw_tdm_p2b-d16893e64187-link">Microservice Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="Orchestrators_Title-d16893e64348" class="topicref" data-id="Orchestrators_Title" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action Orchestrators_Title-d16893e64348-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Orchestration_Pipelines/OrchestrationPipelines_Title.html#Orchestrators_Title" id="Orchestrators_Title-d16893e64348-link">Orchestration Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wr1_ktz_bt-d16893e64489" class="topicref" data-id="concept_wr1_ktz_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wr1_ktz_bt-d16893e64489-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/RPC_Pipelines/SDC_RPCpipelines_title.html#concept_wr1_ktz_bt" id="concept_wr1_ktz_bt-d16893e64489-link">SDC RPC Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fpz_5r4_vs-d16893e64679" class="topicref" data-id="concept_fpz_5r4_vs" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fpz_5r4_vs-d16893e64679-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Cluster_Mode/ClusterPipelines_title.html" id="concept_fpz_5r4_vs-d16893e64679-link">Cluster Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jjk_23z_sq-d16893e65172" class="topicref" data-id="concept_jjk_23z_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jjk_23z_sq-d16893e65172-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Preview/DataPreview_Title.html#concept_jjk_23z_sq" id="concept_jjk_23z_sq-d16893e65172-link">Data Preview</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pgk_brx_rr-d16893e65458" class="topicref" data-id="concept_pgk_brx_rr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pgk_brx_rr-d16893e65458-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Alerts/RulesAlerts_title.html#concept_pgk_brx_rr" id="concept_pgk_brx_rr-d16893e65458-link">Rules and Alerts</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_asx_fdz_sq-d16893e65960" class="topicref" data-id="concept_asx_fdz_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_asx_fdz_sq-d16893e65960-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Monitoring/PipelineMonitoring_title.html#concept_asx_fdz_sq" id="concept_asx_fdz_sq-d16893e65960-link">Pipeline Monitoring</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_o3l_dtr_5q-d16893e66304" class="topicref" data-id="concept_o3l_dtr_5q" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_o3l_dtr_5q-d16893e66304-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Maintenance/PipelineMaintenance_title.html#concept_o3l_dtr_5q" id="concept_o3l_dtr_5q-d16893e66304-link">Pipeline Maintenance</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yms_ftm_sq-d16893e66768" class="topicref" data-id="concept_yms_ftm_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yms_ftm_sq-d16893e66768-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Administration/Administration_title.html#concept_yms_ftm_sq" id="concept_yms_ftm_sq-d16893e66768-link">Administration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nls_w1r_ks-d16893e67508" class="topicref" data-id="concept_nls_w1r_ks" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nls_w1r_ks-d16893e67508-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Tutorial/Tutorial-title.html" id="concept_nls_w1r_ks-d16893e67508-link">Tutorial</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sh3_frm_tq-d16893e68001" class="topicref" data-id="concept_sh3_frm_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sh3_frm_tq-d16893e68001-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Troubleshooting/Troubleshooting_title.html#concept_sh3_frm_tq" id="concept_sh3_frm_tq-d16893e68001-link">Troubleshooting</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xbx_rs1_tq-d16893e68798" class="topicref" data-id="concept_xbx_rs1_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xbx_rs1_tq-d16893e68798-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Glossary/Glossary_title.html#concept_xbx_rs1_tq" id="concept_xbx_rs1_tq-d16893e68798-link">Glossary</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jn1_nzb_kv-d16893e68843" class="topicref" data-id="concept_jn1_nzb_kv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jn1_nzb_kv-d16893e68843-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-DataFormats/DataFormat_Title.html#concept_jn1_nzb_kv" id="concept_jn1_nzb_kv-d16893e68843-link">Data Formats by Stage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pvm_yt3_wq-d16893e68958" class="topicref" data-id="concept_pvm_yt3_wq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pvm_yt3_wq-d16893e68958-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Expression_Language/ExpressionLanguage_title.html" id="concept_pvm_yt3_wq-d16893e68958-link">Expression Language</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vcj_1ws_js-d16893e69669" class="topicref" data-id="concept_vcj_1ws_js" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vcj_1ws_js-d16893e69669-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-RegEx/RegEx-Title.html#concept_vcj_1ws_js" id="concept_vcj_1ws_js-d16893e69669-link">Regular Expressions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_chv_vmj_wr-d16893e69787" class="topicref" data-id="concept_chv_vmj_wr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_chv_vmj_wr-d16893e69787-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-GrokPatterns/GrokPatterns_title.html#concept_chv_vmj_wr" id="concept_chv_vmj_wr-d16893e69787-link">Grok Patterns</a></div></div></li></ul></div>
                        

</div>
</nav>
                    


                    
                    <div id="wh_topic_body" class="col-lg-7 col-md-9 col-sm-12">
<button id="wh_close_publication_toc_button" class="close-toc-button d-none" aria-label="Toggle publishing table of content" aria-controls="wh_publication_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button><button id="wh_close_topic_toc_button" class="close-toc-button d-none" aria-label="Toggle topic table of content" aria-controls="wh_topic_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button>

                        
<div class=" wh_topic_content body "><main role="main"><article class="" role="article" aria-labelledby="ariaid-title1"><article class="nested0" aria-labelledby="ariaid-title1" id="concept_sqc_w4w_ktb">
    <h1 class="- topic/title title topictitle1" id="ariaid-title1">Google BigQuery</h1>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The Google BigQuery executor runs one or more SQLÂ queriesÂ on Google BigQuery each time it
            receives an event record. <span class="- topic/ph ph">For information about supported versions, see <a class="- topic/xref xref" href="../Installation/SupportedSystemVersions.html#concept_s5h_bcr_n4b">Supported Systems and Versions</a>.</span></p>
        <p class="- topic/p p">Use the executor as part of an event stream in the pipeline. For example, you might use
            the Google BigQuery executor to execute a stored procedure in the database when the
            pipeline generates a <a class="- topic/xref xref" href="../Pipeline_Configuration/EventGeneration.html#concept_jcw_n4t_51b">pipeline
                stop event</a>.</p>
        <p class="- topic/p p">When you configure the executor, you specify authentication information for Google
            BigQuery. You can optionally configure the executor to connect to BigQuery through a
            proxy server. </p>
        <p class="- topic/p p">You specify one or more SQL queries to run and how to submit the queries. You can also
            configure the executor to generate events for another event stream, and whether you want
            a query result count included in generated event records. <span class="- topic/ph ph">For more information about dataflow
                        triggers and the event framework, see <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">Dataflow Triggers Overview</a>.</span></p>
        <p class="- topic/p p">Before you use the Google BigQuery executor, you must complete a prerequisite task.</p>
    </div>
<article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title2" id="concept_elb_ftx_ktb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title2">Prerequisite</h2>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">Executing a Google BigQuery SQL query requires that the user specified in the Google
            BigQuery executor has the appropriate BigQuery permissions. </p>
        <div class="- topic/p p">Ensure that the specified user has the following permission:<ul class="- topic/ul ul" id="concept_elb_ftx_ktb__ul_z2p_rld_ltb" data-ofbid="concept_elb_ftx_ktb__ul_z2p_rld_ltb">
                <li class="- topic/li li">bigquery.jobs.create</li>
            </ul></div>
        <p class="- topic/p p">The user might require additional permissions depending on the types of SQL queries
            specified in the executor. For information about permissions needed for different types
            of queries, see the <a class="- topic/xref xref" href="https://cloud.google.com/bigquery/docs/running-queries#required_permissions" target="_blank" rel="external noopener">Google BigQuery documentation</a>. </p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title3" id="concept_ixm_kyx_ktb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title3">Credentials</h2>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">When the Google BigQuery executor connects to BigQuery, the executor must pass
            credentials to Google Cloud Storage and then to Google BigQuery.</p>
        <div class="- topic/p p">You can provide credentials using one the following options:<ul class="- topic/ul ul" id="concept_ixm_kyx_ktb__ul_y31_sth_wmb" data-ofbid="concept_ixm_kyx_ktb__ul_y31_sth_wmb">
                <li class="- topic/li li">Google Cloud default credentials</li>
                <li class="- topic/li li">Credentials in a file</li>
                <li class="- topic/li li">Credentials in a stage property</li>
            </ul></div>
        <p class="- topic/p p">For details on how to configure each option, see <a class="- topic/xref xref" href="../Pipeline_Configuration/GoogleCloud-Credentials.html#concept_vl2_bbx_q1b">Security in Google Cloud Stages</a>.</p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title4" id="concept_lhs_nyy_ktb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title4">SQL Queries</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">You can specify one or more queries to perform each time that the Google BigQuery
            executor receives an event record. </p>
        <p class="- topic/p p">When a query fails, the Google BigQuery executor treats the event record that triggered
            the query like an <a class="- topic/xref xref" href="../Pipeline_Design/ErrorHandling.html#concept_itr_mzw_j1b">error record</a>. If you specify more than one query and multiple queries fail
            for an event record, the executor creates an error record for each failed query, and
            includes query failure details in the header attributes for the error record.</p>
        <div class="- topic/p p">Use the following details to configure the SQL queries:<dl class="- topic/dl dl">
                
                    <dt class="- topic/dt dt dlterm">Query submission</dt>
                    <dd class="- topic/dd dd">Configure the Query Submission property to define how the executor submits
                        your queries:<ul class="- topic/ul ul" id="concept_lhs_nyy_ktb__ul_w5y_n1g_ltb" data-ofbid="concept_lhs_nyy_ktb__ul_w5y_n1g_ltb">
                        <li class="- topic/li li">Sequential - For each incoming event record, the executor submits one
                              query at a time, and waits until the previous query is complete before
                              submitting the next query. Use when the run order for the queries is
                              important. Queries are submitted in the order that they appear in the
                              executor.</li>
                        <li class="- topic/li li">Parallel - For each incoming event record, the executor submits all
                              queries at the same time. Use when the run order for the queries is
                              not important. </li>
                  </ul></dd>
                
                
                    <dt class="- topic/dt dt dlterm">Expressions in queries</dt>
                    <dd class="- topic/dd dd">You can include a subset of the functions provided with the <a class="- topic/xref xref" href="../Expression_Language/ExpressionLanguage_overview.html#concept_p54_4kl_vq">StreamSets expression language</a> in a SQL query. These expressions
                        are evaluated before the executor passes the query to BigQuery.</dd>
                    <dd class="- topic/dd dd ddexpand">
                        <p dir="ltr" class="- topic/p p" id="concept_lhs_nyy_ktb__docs-internal-guid-ead29aea-7fff-8b1c-ab6d-490d1d50da42" data-ofbid="concept_lhs_nyy_ktb__docs-internal-guid-ead29aea-7fff-8b1c-ab6d-490d1d50da42">When entering the query in the executor, use <a class="- topic/xref xref" href="../Expression_Language/ExpressionLanguage_overview.html#concept_tns_krz_sr">expression completion</a> to view the list of valid functions
                            that you can use.</p>
                    </dd>
                
            </dl></div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title5" id="concept_hsy_5vy_ktb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title5">Event Generation</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The Google BigQuery executor can generate events that you can use in an event stream.
            When you enable event generation, the executor generates events for each successful or
            failed query.</p>
        <div class="- topic/p p">Executor events can be used in any logical way. For example: <ul class="- topic/ul ul" id="concept_hsy_5vy_ktb__ul_dzf_tpg_zx" data-ofbid="concept_hsy_5vy_ktb__ul_dzf_tpg_zx">
                <li class="- topic/li li">With the Email executor to send a custom email
                              after receiving an event.<p class="- topic/p p">For an example, see <a class="- topic/xref xref" href="../Solutions/SendEmail.html#concept_t2t_lp5_xz">Sending Email During Pipeline Processing</a>.</p></li>
                <li class="- topic/li li">With a destination to store event information.
                                    <p class="- topic/p p">For an example, see <a class="- topic/xref xref" href="../Solutions/EventStorage.html#concept_ocb_nnl_px">Preserving an Audit Trail of Events</a>.</p></li>
            </ul></div>
        <p class="- topic/p p"><span class="- topic/ph ph">For more information about dataflow
                        triggers and the event framework, see <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">Dataflow Triggers Overview</a>.</span></p>
    </div>
<article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title6" id="concept_ir1_1wy_ktb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title6">Event Records</h3>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <div class="- topic/p p">Event records generated by the Google BigQuery executor have the following event-related
            record header attributes. Record header attributes are stored as String values.<div class="table-container"><table class="- topic/table table frame-all" id="concept_ir1_1wy_ktb__table_brz_3gp_qx" data-ofbid="concept_ir1_1wy_ktb__table_brz_3gp_qx" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                        <tr class="- topic/row">
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__1">Record Header Attribute</th>
                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__2">Description</th>
                        </tr>
                    </thead><tbody class="- topic/tbody tbody">
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__1">sdc.event.type</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__2">Event type. Uses the following event types:<ul class="- topic/ul ul" id="concept_ir1_1wy_ktb__ul_m12_mgp_qx" data-ofbid="concept_ir1_1wy_ktb__ul_m12_mgp_qx">
                                    <li class="- topic/li li">successful-query - Generated after a query successfully
                                        completes. </li>
                                    <li class="- topic/li li">failed-query - Generated after a query fails.</li>
                                </ul></td>
                        </tr>
                        <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__1">sdc.event.version</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__2">Integer that indicates the version of the event record type.</td>
            </tr>
                        <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__1">sdc.event.creation_timestamp</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" id="concept_ir1_1wy_ktb__entry-Event-creationDate" headers="concept_ir1_1wy_ktb__table_brz_3gp_qx__entry__2">Epoch timestamp when the stage created the event.
              </td>
            </tr>
                    </tbody></table></div></div>
        <div class="- topic/p p">The Google BigQuery executor can generate the following types of event records:<dl class="- topic/dl dl">
                
                    <dt class="- topic/dt dt dlterm">Successful query</dt>
                    <dd class="- topic/dd dd">
                        <p class="- topic/p p">The executor generates a successful-query event record after successfully
                            completing a query. </p>
                        <div class="- topic/p p">Successful-query event records have the <code class="+ topic/ph pr-d/codeph ph codeph">sdc.event.type</code>
                            record header attribute set to <code class="+ topic/ph pr-d/codeph ph codeph">sucessful-query</code> and
                            include the following fields: <div class="table-container"><table class="- topic/table table frame-all" id="concept_ir1_1wy_ktb__table_rzy_xd2_pz" data-ofbid="concept_ir1_1wy_ktb__table_rzy_xd2_pz" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                        <tr class="- topic/row">
                                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__1">Event Field Name</th>
                                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__2">Description</th>
                                        </tr>
                                    </thead><tbody class="- topic/tbody tbody">
                                        <tr class="- topic/row">
                                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__1">query</td>
                                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__2">Query completed.</td>
                                        </tr>
                                        <tr class="- topic/row">
                                            <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__1">query-result</td>
                                            <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_ir1_1wy_ktb__table_rzy_xd2_pz__entry__2">Number of rows affected by query. Included if the
                                                Query Result Count in Events property is
                                                selected.</td>
                                        </tr>
                                    </tbody></table></div></div>
                    </dd>
                
                
                    <dt class="- topic/dt dt dlterm">Failed query</dt>
                    <dd class="- topic/dd dd">
                        <p class="- topic/p p">The executor generates a failed-query event record after failing to
                            complete a query.</p>
                        <div class="- topic/p p">Failed-query event records have the <code class="+ topic/ph pr-d/codeph ph codeph">sdc.event.type</code>
                            record header attribute set to <code class="+ topic/ph pr-d/codeph ph codeph">failed-query</code> and include
                            the following field: <div class="table-container"><table class="- topic/table table frame-all" id="concept_ir1_1wy_ktb__table_jtk_zd2_pz" data-ofbid="concept_ir1_1wy_ktb__table_jtk_zd2_pz" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                        <tr class="- topic/row">
                                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_ir1_1wy_ktb__table_jtk_zd2_pz__entry__1">Event Field Name</th>
                                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_ir1_1wy_ktb__table_jtk_zd2_pz__entry__2">Description</th>
                                        </tr>
                                    </thead><tbody class="- topic/tbody tbody">
                                        <tr class="- topic/row">
                                            <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_ir1_1wy_ktb__table_jtk_zd2_pz__entry__1">query</td>
                                            <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_ir1_1wy_ktb__table_jtk_zd2_pz__entry__2">Query attempted.</td>
                                        </tr>
                                    </tbody></table></div></div>
                    </dd>
                
            </dl></div>
    </div>
</article></article><article class="- topic/topic task/task topic task nested1" aria-labelledby="ariaid-title7" id="task_pqv_nrb_btb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title7">Configuring a Google BigQuery Executor </h2>
    
    <div class="- topic/body task/taskbody body taskbody"><p class="- topic/shortdesc shortdesc"></p>
        <section class="- topic/section task/context section context">Configure a Google BigQuery executor to run a SQL query on Google BigQuery upon
            receiving an event. Before you use the executor in a pipeline, complete the <a class="- topic/xref xref" href="GBQuery-E.html#concept_elb_ftx_ktb">prerequisite</a> task.</section>
        <section class="- topic/ol task/steps ol steps"><ol class="- topic/ol task/steps ol steps"><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">In the Properties panel, on the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">General</span> tab, configure the
                    following properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_pqv_nrb_btb__table_yxz_pvs_6f" data-ofbid="task_pqv_nrb_btb__table_yxz_pvs_6f" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1">General Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1">Name</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Stage name.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1">Description</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Optional description.</td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1"><a class="- topic/xref xref" href="GBQuery-E.html#concept_hsy_5vy_ktb">Produce Events</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Generates event records when events occur. Use for
                  <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">event handling</a>.</td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/DroppingUnwantedRecords.html#concept_dnj_bkm_vq">Required Fields</a></td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Fields that must include data for the record to be passed into the stage. <div class="- topic/note note tip note_tip"><span class="note__title">Tip:</span> You might include fields that the stage
                  uses.</div><p class="- topic/p p">Records that do not include all required fields are processed based
                  on the error handling configured for the pipeline.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/DroppingUnwantedRecords.html#concept_msl_yd4_fs">Preconditions</a></td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Conditions that must evaluate to TRUE to allow a record to enter the stage for
                processing. Click <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> to create additional preconditions.
                  <p class="- topic/p p">Records that do not meet all preconditions are processed based on the error
                  handling configured for the stage.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/ErrorHandling.html#concept_atr_j4y_5r">On
                  Record Error</a></td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_pqv_nrb_btb__table_yxz_pvs_6f__entry__2">Error record handling for the stage: <ul class="- topic/ul ul" id="task_pqv_nrb_btb__ul_atl_2rx_mx" data-ofbid="task_pqv_nrb_btb__ul_atl_2rx_mx">
                  <li class="- topic/li li">Discard - Discards the record.</li>
                  <li class="- topic/li li">Send to Error - Sends the record to the pipeline for error handling.</li>
                  <li class="- topic/li li">Stop Pipeline - Stops the pipeline.</li>
                </ul></td>
            </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Google BigQuery</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_pqv_nrb_btb__table_phz_fmp_wmb" data-ofbid="task_pqv_nrb_btb__table_phz_fmp_wmb" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Google BigQuery Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                
                                <tr class="- topic/row">
                        <td class="- topic/entry entry colsep-1 rowsep-1" id="task_pqv_nrb_btb__entry_GoogleProjectID" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Project ID</td>
                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">
                            <p class="- topic/p p" id="task_pqv_nrb_btb__p-ProjectIDDescription" data-ofbid="task_pqv_nrb_btb__p-ProjectIDDescription">Google Cloud project ID to use.</p>
                        </td>
                    </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1"><a class="- topic/xref xref" href="../Pipeline_Configuration/GoogleCloud-Credentials.html#concept_vl2_bbx_q1b">Credentials Provider</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Provider for Google Cloud
                            credentials: <ul class="- topic/ul ul" id="task_pqv_nrb_btb__ul_phk_wgd_xmb" data-ofbid="task_pqv_nrb_btb__ul_phk_wgd_xmb">
                                <li class="- topic/li li">Default credentials provider - Uses Google Cloud default
                                    credentials.</li>
                                <li class="- topic/li li">Service account credentials file (JSON) - Uses credentials
                                    stored in a JSON service account credentials file.</li>
                                <li class="- topic/li li">Service account credentials (JSON) - Uses JSON-formatted
                                    credentials information from a service account credentials
                                    file.</li>
                            </ul></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1"><a class="- topic/xref xref" href="../Pipeline_Configuration/GoogleCloud-Credentials.html#concept_xxg_lgr_v1b">Credentials File Path (JSON) </a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2"><span class="- topic/ph ph">Path to the Google Cloud
                                service account credentials file used to connect. The credentials
                                file must be a JSON file.</span><p class="- topic/p p">Enter a path relative to the
                                    <span class="- topic/ph ph">Data Collector</span> resources directory, <code class="+ topic/ph pr-d/codeph ph codeph">$SDC_RESOURCES</code>, or enter an
                                absolute path.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1"><a class="- topic/xref xref" href="../Pipeline_Configuration/GoogleCloud-Credentials.html#concept_ik1_pqp_wmb">Credentials File Content (JSON)</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2"><span class="- topic/ph ph">Contents of a Google Cloud
                                service account credentials JSON file used to
                                    connect.</span><p class="- topic/p p"><span class="- topic/ph ph">Enter
                                    JSON-formatted credential information in plain text, or use an
                                    expression to call the information from</span>
                                            <a class="- topic/xref xref" href="../Pipeline_Configuration/RuntimeValues.html#concept_bs4_5nm_2s" title="Similar to runtime properties, runtime resources are values that you define in a file local to the Data Collector and call from within a pipeline. But with runtime resources, you can restrict the permissions for the files to secure information.">runtime resources</a> or a <span class="- topic/ph ph"><span class="- topic/ph ph"><a class="- topic/xref xref" href="../Configuration/CredentialStores.html#concept_bt1_bpj_r1b">credential store.</a></span></span></p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Connection Pool Size</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Maximum number of connections that the executor uses to
                                        connect to Google BigQuery. Default is 0, which ensures that
                                        the destination uses the same number of connections as
                                        threads used by the pipeline.<p class="- topic/p p">When loading to multiple
                                            tables, increasing this property can improve
                                            performance.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Enable Proxy</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Connects to the Google BigQuery API through an HTTP proxy
                                        server.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Proxy URL</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">URL of the HTTP proxy server in the following
                                                format:<p class="- topic/p p"><code class="+ topic/ph pr-d/codeph ph codeph">http://&lt;host&gt;:&lt;port&gt;</code></p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Proxy Username</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Optional user name to authenticate with the proxy
                                        server.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Proxy Password</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Optional password to authenticate with the proxy
                                        server.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Use Legacy SQL</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Enables using Google BigQuery legacy SQL instead of
                                        standard SQL in SQL queries.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__1">Use Cached Query Results</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_pqv_nrb_btb__table_phz_fmp_wmb__entry__2">Uses the query results cached on Google Cloud Storage.
                                            <p class="- topic/p p">Use this option with caution.</p></td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Queries</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_pqv_nrb_btb__table_y5h_4jn_qqb" data-ofbid="task_pqv_nrb_btb__table_y5h_4jn_qqb" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__1">Queries Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__1"><a class="- topic/xref xref" href="GBQuery-E.html#concept_lhs_nyy_ktb">SQL
                                            Queries</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__2">One or more SQL queries to execute upon receiving an
                                        event record. By default, queries are executed in the
                                        specified order. <p class="- topic/p p">To add additional queries, click
                                                <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span>.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__1">Query Submission</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__2">Determines how the executor submits multiple queries:<ul class="- topic/ul ul" id="task_pqv_nrb_btb__ul_hjt_m1g_ltb" data-ofbid="task_pqv_nrb_btb__ul_hjt_m1g_ltb">
                        <li class="- topic/li li">Sequential - For each incoming event record, the executor submits one
                              query at a time, and waits until the previous query is complete before
                              submitting the next query. Use when the run order for the queries is
                              important. Queries are submitted in the order that they appear in the
                              executor.</li>
                        <li class="- topic/li li">Parallel - For each incoming event record, the executor submits all
                              queries at the same time. Use when the run order for the queries is
                              not important. </li>
                  </ul><p class="- topic/p p">By default, the executor waits for a query to
                                            complete before submitting the next query.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__1">Include Query Result Count in Events</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__2">When the executor is configured to generate events, the
                                        executor includes query result counts in event
                                        records.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__1">Query Timeout (sec)</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_pqv_nrb_btb__table_y5h_4jn_qqb__entry__2">Seconds to wait for the results of the query.</td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li></ol></section>
    </div>
</article></article></article></main></div>

                        
                        
                        


                    </div>
                    
                </div>
            </div>


        </div> <nav class="navbar navbar-default wh_footer" data-whc_version="25.0">
  <div class=" footer-container  mx-auto">
    <!-- script for Data Collector, all flavors, but only used when accessed directly, not from portal --><script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-60917135-3', 'auto');
  ga('send', 'pageview');
</script>
  </div>
</nav>

        
        <div id="go2top">
            <span class="oxy-icon oxy-icon-up"></span>
        </div>
        
        <!-- The modal container for images -->
        <div id="modal_img_large" class="modal">
            <span class="close oxy-icon oxy-icon-remove"></span>
            <!-- Modal Content (The Image) -->
            <div id="modal_img_container"></div>
            <!-- Modal Caption (Image Text) -->
            <div id="caption"></div>
        </div>
        
        
        Â© 2023 StreamSets, Inc.

    </body>
</html>